/****** Object:  StoredProcedure [dbo].[sp_KCL_CheckUserLogin]    Script Date: 04/25/2011 00:27:43 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[sp_KCL_CheckUserLogin]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[sp_KCL_CheckUserLogin]
GO

/****** Object:  StoredProcedure [dbo].[sp_KCL_CheckUserLogin]    Script Date: 04/25/2011 00:27:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- ==================================================================================
-- Revision History:
-- Date					Author			Description
-- 23-04-2011			btnam			Create script
-- ==================================================================================

CREATE PROCEDURE [dbo].[sp_KCL_CheckUserLogin]

	@Username			NVARCHAR(100),
	@Password			NVARCHAR(100)
	
AS
BEGIN
	
	SET NOCOUNT ON;
	
	SELECT [fullname], [admin], [read], [create], [edit]
	FROM [User]
	WHERE [isActive] = 1
		  AND [username] = @Username
		  AND [password] = @Password
    
END

GO


